Lookup Data Table

Looks up given data table to find the desired value. Returns row index of first match.

Input

• DataTable: This is the area where the Data Table object to be searched is defined.
  • Type: System.Data.DataTable
  • Required
• Lookup Value: The value you want to search for in the specified DataTable variable.
  • Type: System.String
  • Required

Output

• Cell Value: This is the area where the variable to which the cell value in the search result will be assigned is defined.
  • Type: System.Object
• Row Index: This is the area where the variable to which the row index value in the search result will be assigned is defined.
  • Type: System.Int32

Lookup

• Column: The object of the data column from which the value will be retrieved.
  • Type: System.Data.DataColumn
• Column Name: The name of the data column from which the value will be retrieved.
  • Type: System.String
• Column Index: The index of the column you want to search for. This field supports only Int32 variables.
  • Type: System.Int32

Target Column

• Column: The object of the data column from which the value will be retrieved.
  • Type: System.Data.DataColumn
• Column Name: The name of the data column from which the value will be retrieved.
  • Type: System.String
• Column Index: The name of the data column from which the value will be retrieved.
  • Type: System.Int32